﻿/********************************************************************************************************************
* Author:	Aristidis Mihail																						*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_category_getusers"						*		
*			 that returns all users from a private category.														*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_category_getusers]
	@categoryid bigint 
AS
	SELECT userid
	FROM [Category-User]
	WHERE CategoryID = @categoryid
RETURN 0